﻿USE [tippelde]
GO
/****** Object:  Table [dbo].[Users]    Script Date: 11/15/2013 17:22:30 ******/
INSERT [dbo].[Users] ([Id], [UserName], [PasswordHash], [SecurityStamp], [Discriminator]) VALUES (N'7ab505bd-454d-4b7b-a2d1-b380266d14d8', N'pnovak', NULL, N'b70712ec-a81c-4bec-9fea-6fd292781c10', N'User')
INSERT [dbo].[Users] ([Id], [UserName], [PasswordHash], [SecurityStamp], [Discriminator]) VALUES (N'f6e369dc-526a-46c3-b5ae-eaa9e231a475', N'npeete', NULL, N'7535dbfa-6a8a-4ce1-84bf-513906f9882d', N'User')
/****** Object:  Table [dbo].[Teams]    Script Date: 11/15/2013 17:22:30 ******/
SET IDENTITY_INSERT [dbo].[Teams] ON
INSERT [dbo].[Teams] ([Id], [Name], [ShortName], [LogoUrl], [Description]) VALUES (1, N'Magyarország', N'HUN', N'https://upload.wikimedia.org/wikipedia/commons/0/00/Flag_of_Hungary.png', NULL)
INSERT [dbo].[Teams] ([Id], [Name], [ShortName], [LogoUrl], [Description]) VALUES (2, N'Németország', N'GER', N'http://m.cdn.blog.hu/co/couchsurfing/image/german-flag.jpeg', NULL)
INSERT [dbo].[Teams] ([Id], [Name], [ShortName], [LogoUrl], [Description]) VALUES (3, N'Brazília', N'BRA', N'http://www.papiruszportal.hu/kepek/tarsadalom/2006_10/brazil_7_03.jpg', NULL)
INSERT [dbo].[Teams] ([Id], [Name], [ShortName], [LogoUrl], [Description]) VALUES (4, N'Lombard Pápa', N'Pápa', N'http://www.magyarfutball.hu/data/logos/0/0044/logo_0044_01.png', NULL)
INSERT [dbo].[Teams] ([Id], [Name], [ShortName], [LogoUrl], [Description]) VALUES (5, N'Újpest FC', N'ÚFC', N'http://www.magyarfutball.hu/data/logos/0/0006/logo_0006_06.png', NULL)
INSERT [dbo].[Teams] ([Id], [Name], [ShortName], [LogoUrl], [Description]) VALUES (6, N'Ferencvárosi Torna Club', N'FTC', N'http://www.magyarfutball.hu/data/logos/0/0001/logo_0001_02.png', NULL)
INSERT [dbo].[Teams] ([Id], [Name], [ShortName], [LogoUrl], [Description]) VALUES (7, N'MVM-Paksi FC', N'Paks', N'http://www.magyarfutball.hu/data/logos/0/0013/logo_0013_01.png', NULL)
SET IDENTITY_INSERT [dbo].[Teams] OFF
/****** Object:  Table [dbo].[Roles]    Script Date: 11/15/2013 17:22:30 ******/
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (N'1', N'admin')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (N'2', N'teammanager')
/****** Object:  Table [dbo].[Events]    Script Date: 11/15/2013 17:22:30 ******/
SET IDENTITY_INSERT [dbo].[Events] ON
INSERT [dbo].[Events] ([Id], [EventDate], [BetStartAt], [BetEndAt], [Available], [Name], [ShortName], [Status], [Creator_Id]) VALUES (1, CAST(0x0000A27F01499700 AS DateTime), CAST(0x0000A272013CC1A2 AS DateTime), CAST(0x0000A27F0128A180 AS DateTime), 0, N'Bajnoki 15. forduló', N'NB1', 0, N'7ab505bd-454d-4b7b-a2d1-b380266d14d8')
SET IDENTITY_INSERT [dbo].[Events] OFF
/****** Object:  Table [dbo].[Logs]    Script Date: 11/15/2013 17:22:30 ******/
/****** Object:  Table [dbo].[Groups]    Script Date: 11/15/2013 17:22:30 ******/
SET IDENTITY_INSERT [dbo].[Groups] ON
INSERT [dbo].[Groups] ([Id], [Name], [ShortName], [Description], [Creator_Id]) VALUES (1, N'Foci VB 2014', N'VB14', NULL, N'f6e369dc-526a-46c3-b5ae-eaa9e231a475')
INSERT [dbo].[Groups] ([Id], [Name], [ShortName], [Description], [Creator_Id]) VALUES (2, N'Teszt csoport', N'TESZT', NULL, N'f6e369dc-526a-46c3-b5ae-eaa9e231a475')
INSERT [dbo].[Groups] ([Id], [Name], [ShortName], [Description], [Creator_Id]) VALUES (3, N'Mennyei Bajnokság', N'NB1', NULL, N'7ab505bd-454d-4b7b-a2d1-b380266d14d8')
SET IDENTITY_INSERT [dbo].[Groups] OFF
/****** Object:  Table [dbo].[UserClaims]    Script Date: 11/15/2013 17:22:30 ******/
/****** Object:  Table [dbo].[UserRoles]    Script Date: 11/15/2013 17:22:30 ******/
INSERT [dbo].[UserRoles] ([UserId], [RoleId]) VALUES (N'f6e369dc-526a-46c3-b5ae-eaa9e231a475', N'1')
INSERT [dbo].[UserRoles] ([UserId], [RoleId]) VALUES (N'f6e369dc-526a-46c3-b5ae-eaa9e231a475', N'2')
/****** Object:  Table [dbo].[UserLogins]    Script Date: 11/15/2013 17:22:30 ******/
INSERT [dbo].[UserLogins] ([UserId], [LoginProvider], [ProviderKey]) VALUES (N'7ab505bd-454d-4b7b-a2d1-b380266d14d8', N'Facebook', N'1027134664')
INSERT [dbo].[UserLogins] ([UserId], [LoginProvider], [ProviderKey]) VALUES (N'f6e369dc-526a-46c3-b5ae-eaa9e231a475', N'Google', N'https://www.google.com/accounts/o8/id?id=AItOawm-fmctTGC7dbs2jfsNil8RnP7BO43CjMU')
/****** Object:  Table [dbo].[UserGroups]    Script Date: 11/15/2013 17:22:30 ******/
INSERT [dbo].[UserGroups] ([UserId], [GroupId]) VALUES (N'7ab505bd-454d-4b7b-a2d1-b380266d14d8', 2)
INSERT [dbo].[UserGroups] ([UserId], [GroupId]) VALUES (N'7ab505bd-454d-4b7b-a2d1-b380266d14d8', 3)
INSERT [dbo].[UserGroups] ([UserId], [GroupId]) VALUES (N'f6e369dc-526a-46c3-b5ae-eaa9e231a475', 1)
INSERT [dbo].[UserGroups] ([UserId], [GroupId]) VALUES (N'f6e369dc-526a-46c3-b5ae-eaa9e231a475', 2)
/****** Object:  Table [dbo].[Results]    Script Date: 11/15/2013 17:22:30 ******/
/****** Object:  Table [dbo].[GroupEvents]    Script Date: 11/15/2013 17:22:30 ******/
INSERT [dbo].[GroupEvents] ([Group_Id], [Event_Id]) VALUES (2, 1)
INSERT [dbo].[GroupEvents] ([Group_Id], [Event_Id]) VALUES (3, 1)
/****** Object:  Table [dbo].[EventDescriptors]    Script Date: 11/15/2013 17:22:30 ******/
INSERT [dbo].[EventDescriptors] ([Id], [Name], [Description], [EventInfo], [Team_Id], [Team_Id1], [AwayTeam_Id], [HomeTeam_Id]) VALUES (1, N'Bajnoki 15. forduló', NULL, N'NB1', NULL, NULL, 4, 5)
/****** Object:  Table [dbo].[Bets]    Script Date: 11/15/2013 17:22:30 ******/
SET IDENTITY_INSERT [dbo].[Bets] ON
INSERT [dbo].[Bets] ([Id], [HomeBet], [AwayBet], [BetAt], [Checked], [Event_Id], [User_Id]) VALUES (1, 1, 1, CAST(0x0000A2770105CB75 AS DateTime), 0, 1, N'f6e369dc-526a-46c3-b5ae-eaa9e231a475')
SET IDENTITY_INSERT [dbo].[Bets] OFF
/****** Object:  Table [dbo].[BetResults]    Script Date: 11/15/2013 17:22:30 ******/
